clear 
set more off
cd "$Mydirectory1/1_DataSources/NLSYW68/"

import delimited ./rawdata/hhsize.csv, case(preserve)  clear

label define vlR0070600 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R0070600 vlR0070600

label define vlR0134351 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R0134351 vlR0134351

label define vlR0212571 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R0212571 vlR0212571

label define vlR0326151 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R0326151 vlR0326151

label define vlR0414951 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R0414951 vlR0414951

label define vlR0502300 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R0502300 vlR0502300

label define vlR0649000 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R0649000 vlR0649000

label define vlR0752700 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R0752700 vlR0752700

label define vlR0766700 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R0766700 vlR0766700

label define vlR0878300 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R0878300 vlR0878300

label define vlR0960500 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R0960500 vlR0960500

label define vlR1081000 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R1081000 vlR1081000

label define vlR1184000 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R1184000 vlR1184000

label define vlR1313200 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R1313200 vlR1313200

label define vlR1421800 -99999 "-99999 TO 0: < 1"  1 "1: = 1"  2 "2"  3 "3"  4 "4"  5 "5"  6 "6"  7 "7"  8 "8"  9 "9"  10 "10"  11 "11"  12 "12"  13 "13"  14 "14"  15 "15"  16 "16"  17 "17 TO 999999: 17+" 
label values R1421800 vlR1421800

  rename R0000100 R0000100_1968 
  rename R0070600 R0070600_1968 
  rename R0134351 R0134351_1969 
  rename R0212571 R0212571_1970 
  rename R0326151 R0326151_1971 
  rename R0414951 R0414951_1972 
  rename R0502300 R0502300_1973 
  rename R0649000 R0649000_1978 
  rename R0752700 R0752700_1980 
  rename R0766700 R0766700_1982 
  rename R0878300 R0878300_1983 
  rename R0960500 R0960500_1985 
  rename R1081000 R1081000_1987 
  rename R1184000 R1184000_1988 
  rename R1313200 R1313200_1991 
  rename R1421800 R1421800_1993 

  sort R0000100_1968
  save ./rawdata/hhsize.dta, replace

